You are here: Integrations > Bulk Loader > Requirements for Bulk Loader Source Files > Course Manager Requirements

Course Manager Requirements

The Course Manager Loader enables you to bulk Update or create new LearnCenter (WYSIWYG) or Document Courses and update Existing SCORM and AICC Courses. You can also create Courses based on template Courses you have already created. This loader expects the following items to be preexisting to create LearnCenter (WYSIWYG) Courses:

Bulk Loader data files do not support characters with the grave accent.

Course Type

Text Editor Column Required Notes
1 A
  • Yes if no Course ID is in Column 3
  • No Yes if there is a Course ID in Column 3
Course Type
Accepted Values

The Course Completion loader will create or update User completion records for the following Course types:

  • AICC = AICC Course
  • SCORM = SCORM Course
  • LearnCenter = LearnCenter (WYSIWYG) Course
  • Document = Document Course created from the Content Manager
  • Example: AICC
  • Example: SCORM
  • Example: LearnCenter
  • Example: Document
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes
Classes are not supported for loading completions
Use Caution. When using the Course ID as the Unique identifier it is possible to update existing Courses in the current LearnCenter or any Sub-LearnCenter

Course Name

Text Editor Column Required Notes
2 B
  • Yes if no Course ID is in Column 3
  • No Yes if there is a Course ID in Column 3
Course Name The name is the used to find existing Courses.
Accepted Values

Any Value up to 1000 characters in length

  • Example: AICC
  • Example: SCORM
  • Example: LearnCenter
  • Example: Document
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes
Use Caution. When using the Course ID as the Unique identifier it is possible to update existing Courses in the current LearnCenter or any Sub-LearnCenter.

 

Course ID

Text Editor Column Required Notes
3 C
  • Yes if no Course ID is in Column 3
  • No if there is a Course ID in Column 3
Course ID
Accepted Values

The LearnCenter System generated Course ID

  • Example: 6287
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes
The Course ID is the Primary Identifier to find existing Course, if included in the data file the Course Type and Name fields will not be used to find the existing Course.
The Course ID can be retrieved using BI Reporting and running the standard Course List Report. In the report add the Course ID, this is the system generated Course ID to add to the data file.
Use Caution. When using the Course ID as the Unique identifier it is possible to update existing Courses in the current LearnCenter or any Sub-LearnCenter.

Description

Text Editor Column Required Notes
4 D
  • No
Course Description
Accepted Values

Any Value up to 4000 characters in length

Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes

Include in LearnCenter Search

Text Editor Column Required Notes
5 E
  • No
Set the LearnCenter Course to be included in the Learn Advanced Search.
Accepted Values
  • Yes = Sets the LearnCenter Course to be included in LearnCenter Search
  • No = Sets the LearnCenter Course to NOT be included in LearnCenter Search
  • Blank or <null> = Sets the LearnCenter Course to NOT be included in LearnCenter Search
  • Example: Yes
  • Example: No
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes

Display Electronic Signature Start of Course

Text Editor Column Required Notes
6 F
  • No
Electronic Signature Name
Accepted Values

Any Electronic Signature Name

  • Example: Default - Will use the Default Electronic Signature
  • Example: Demo Electronic Signature
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes
This field sets the Electronic Signature for the beginning of the Course only.

Display Electronic Signature End of Course

Text Editor Column Required Notes
7 G
  • No
Electronic Signature Name
Accepted Values

Any Electronic Signature Name

  • Example: Default - Will use the Default Electronic Signature
  • Example: Demo Electronic Signature
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes
This field set the Electronic Signature for the end of the Course only

Display to Public

Text Editor Column Required Notes
8 H
  • No
Set the Course to be displayed in the Public Catalog.
Accepted Values
  • Yes = Sets the Course to be displayed in the Public Catalog
  • No = Sets the Course to NOT be displayed in the Public Catalog
  • Blank or <null> = Sets the Course to NOT be displayed in the Public Catalog
  • Example: Yes
  • Example: No
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes
This field set the Electronic Signature for the end of the Course only

Display Feedback Form

Text Editor Column Required Notes
9 I
  • No
Set the Feedback Form to be displayed to the User after the Course.
Accepted Values
  • Inherited = will Inherited setting from the LearnCenter setting
  • Yes = Sets the Feedback Form to be displayed to User after the Course
  • No = Sets the Feedback Form to NOT be displayed to User after the Course
  • Blank or <null> = Set to Inherited
  • Example: Yes
  • Example: No
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes

Always Show Next Button

Text Editor Column Required Notes
10 J
  • No
Set the Always Show Next button.
Accepted Values
  • Inherited = Set to Inherited
  • Yes = Set the Course Player to always show next button
  • No = Set the Course Player to NOT show next button
  • Blank or <null> = Set to Inherited
  • Example: Yes
  • Example: No
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes No (Field Skipped)
Applies to Legacy Standard Course Player

Center Navigation Buttons Only

Text Editor Column Required Notes
11 K
  • No
Set navigation button to center.
Accepted Values
  • Inherited = Set to Inherited
  • Yes = Set the Course Player to center navigation buttons
  • No = Set the Course Player to not center navigation buttons
  • Blank or <null> = Set to Inherited
  • Example: Yes
  • Example: No
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes No (Field Skipped)
Applies to Legacy Standard Course Player

Show Navigation Buttons

Text Editor Column Required Notes
12 L
  • No
Set Navigation Buttons to show.
Accepted Values
  • Inherited = will Inherited setting from the LearnCenter setting
  • Yes = Set the Course Player to show navigation buttons
  • No = Set the Course Player to not show navigation buttons
  • Blank or <null> = Set to Inherited
  • Example: Yes
  • Example: No
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes No (Field Skipped)
Applies to Legacy Standard Course Player

Show Information Bar

Text Editor Column Required Notes
13 M
  • No
Set Course Player to show information bar.
Accepted Values
  • Inherited = will Inherited setting from the LearnCenter setting
  • Yes = Set the Course Player to show information bar
  • No = Set the Course Player to not show information bar
  • Blank or <null> = Set to Inherited
  • Example: Yes
  • Example: No
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes No (Field Skipped)
Applies to Legacy Standard Course Player

Close External Window

Text Editor Column Required Notes
14 N
  • No
Set Course Player to close external window.
Accepted Values
  • Inherited = will Inherited setting from the LearnCenter setting
  • Yes = Set the Course Player to show information bar
  • No = Set the Course Player to not show information bar
  • Blank or <null> = Set to Inherited
  • Example: Yes
  • Example: No
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
No (Field Skipped) Yes Yes No (Field Skipped)
Applies to Legacy Standard Course Player. Close on SCORM API Session Finish applies to SCORM 1.2 and 2004 Courses.

Scoring Behavior

Text Editor Column Required Notes
15 O
  • No
Set Course Scoring Behavior.
Accepted Values
  • Inherited = Set to Inherited
  • Always Update = Set to Always Update
  • Retain Highest = Set to Retain Highest
  • Retain First = Set to Retain First
  • Blank or <null> = Inherited
  • Example: Inherited
  • Example: Always Update
  • Example: Retain Highest
  • Example: Retain First
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes No (Field Skipped)

Keep Session Alive

Text Editor Column Required Notes
16 P
  • No
Sets Keep Session Alive to Active on Inactive.
Accepted Values
  • Inherited = will Inherited setting from the LearnCenter setting
  • Yes = Set Keep session alive to active
  • No = Set Keep session alive to inactive
  • Blank or <null> = Set to Inherited
  • Example: Yes
  • Example: No
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes

Auto-Commit Completion/Bookmarking Elements

Text Editor Column Required Notes
17 Q

No

Set SCORM Course Auto-Commit Completion/Bookmarking Elements.
Accepted Values
  • Inherited = will Inherited setting from the LearnCenter setting
  • Yes = Enables the SCORM Auto-Commit Completion/Bookmarking Elements
  • No = Disables the SCORM Auto-Commit Completion/Bookmarking Elements
  • Blank or <null> = Set to Inherited
  • Example: Inherited
  • Example: Yes
  • Example: No
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
No (Field Skipped) Yes No (Field Skipped) No (Field Skipped)
Applies to SCORM Courses only

Use AJAX Communication

Text Editor Column Required Notes
18 R

No

Set Course Player to Use AJAX Communication.
Accepted Values
  • Inherited = Inherit setting from the LearnCenter level
  • Yes = Set the Course Player to Use AJAX Communication
  • No = Set the Course Player to not Use AJAX Communication
  • Blank or <null> = Sets to Inherited
  • Example: Inherited
  • Example: Yes
  • Example: No
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
No (Field Skipped) Yes No (Field Skipped) No (Field Skipped)
Applies to SCORM Courses only
Applies to Legacy Standard Course Player.

Commit Behavior

Text Editor Column Required Notes
19 S

No

Set Course Commit Behavior.
Accepted Values
  • Inherited = will Inherited setting from the LearnCenter setting
  • Always Update = Set to Always Update
  • Interval-Based = Set to Interval-Based
  • Blank or <null> = Set to Inherited
  • Example: Inherited
  • Example: Always Update
  • Example: Interval-Based
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses.
No (Field Skipped) Yes No (Field Skipped) No (Field Skipped)
Applies to SCORM Courses only
Applies to Legacy Standard Course Player.

Failed Completion Status

Text Editor Column Required Notes
20 T

No

Set Course Failed Completion Status.
Accepted Values
  • Inherited = will Inherited setting from the LearnCenter setting
  • Complete = Set to Always Complete
  • Incomplete = Set to Incomplete
  • Blank or <null> = Set to Inherited
  • Example: Inherited
  • Example: Complete
  • Example: Incomplete
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
No (Field Skipped) Yes No (Field Skipped) No (Field Skipped)
Applies to SCORM Courses only
Applies to Legacy Standard Course Player.

Show Header

Text Editor Column Required Notes
21 U

No

Set Standard Course Player to Show Header.
Accepted Values
  • Inherited = Inherit setting from the LearnCenter level
  • Yes = Set the Course Player to Use AJAX Communication
  • No = Set the Course Player to not Use AJAX Communication
  • Blank or <null> = Sets to Inherited
  • Example: Inherited
  • Example: Yes
  • Example: No
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes No (Field Skipped)
Applies to Legacy Standard Course Player.

Display Completion Certificate

Text Editor Column Required Notes
22 V

No

Sets the Display Course Completion Certificate for the Course.
Accepted Values
  • Inherited = Inherit setting from the LearnCenter level
  • Yes = Set to display the Completion Certificate for the Course
  • No = Set to not display the Completion Certificate for the Course
  • Blank or <null> = Sets to Inherited
  • Example: Inherited
  • Example: Yes
  • Example: No
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes
Mapping of a specific Completion Certificate is completed in the Control Panel > Advanced Learning >Certificates

Author

Text Editor Column Required Notes
23 W

No

Set the Course Author Standard Field.
Accepted Values

Any value up to 50 characters

Example: Don Bircher

Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes

Series Name

Text Editor Column Required Notes
24 X

No

Set the Course Series Number Standard Field .
Accepted Values

Any value up to 50 characters

Example: Series 101

Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes

Series Number

Text Editor Column Required Notes
25 Y

No

Set the Course Series Number Standard Field.
Accepted Values

Any value up to 50 characters

Example: Series 101

Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes

Course Level

Text Editor Column Required Notes
26 Z

No

Set the Course Series Number Standard Field Set the Course Series Number Standard Field.
Accepted Values

Any value up to 50 characters

Example: Level 101

Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes

Credits

Text Editor Column Required Notes
27 AA

No

Set the Course Credits Standard Field.
Accepted Values

Numeric value from 0 to 9999999

Example: 10

Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes

Duration

Text Editor Column Required Notes
28 AB

No

Set the Course Duration Standard Field.
Accepted Values

Numeric value from 0 to 99999999

Example: 10

Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes

Publisher

Text Editor Column Required Notes
29 AC

No

Set the Course Publisher Standard Field.
Accepted Values

Any value up to 50 characters

Example: Published by ABC Company

Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes

Cost Per User

Text Editor Column Required Notes
30 AD

No

Set the Course Cost Per User Standard Field.
Accepted Values

Numeric value from 0 to 9999999

Example: 100

Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes

Course Number

Text Editor Column Required Notes
31 AE

No

Set the Course Number Standards Field.
Accepted Values

Any value up to 50 characters

  • Example: The Course number is 101
  • Example: 101
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes

Insert Existing Course

Text Editor Column Required Notes
32 AF

No

Places the Course in the Warehouse or Showroom (Inserted into the LearnCenter).
Accepted Values
  • Yes = Puts (Inserts) the Course into the Showroom
  • No = Puts the Course into the Warehouse
  • Blank or <null> = Puts the Course into the Warehouse
  • Example: Yes
  • Example: No
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes
Using the update existing records the Course can be moved between the Warehouse and Showroom Course must be in the Showroom (inserted into the LearnCenter) to report on progress for the Course.

Populate Custom Field Default Values

Text Editor Column Required Notes
33 AG

No

Populates custom fields with Default Values.
Accepted Values
  • Yes = Populates custom fields with default values
  • No = Does not populates custom fields with default values
  • Blank or <null> = Does not populates custom fields with default values
  • Example: Yes
  • Example: No
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes

Course Custom Fields

Text Editor Column Required Notes
34 AH

No

Set the Course Custom Fields.
Accepted Values
  • The Application can load data into as many custom fields as exist in the LearnCenter for LearnCenter Courses
  • For format if the data in the column: <custom field name>=<custom field data>
  • Each custom field mapping is separated by a semicolon ;
  • The custom fields must exist in the LearnCenter
  • The custom Fields for the Courses must be unique.
  • If multiple custom fields (For the Course) with the exact same name exist, the application cannot determine which field to map the data to and will skip the field.
  • Example: Course Custom Field 01=Custom Data Set 01
  • Example: Course Custom Field 01=Custom Data Set 01;Course Custom Field 02=Custom Data Set 02;Course Custom Field 03=Custom Data Set 03
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes
Custom Field must exist and have unique names If more than one Course custom field is found with the same name this will be an error condition and outputted to the results file..

Categories

Text Editor Column Required Notes
35 AI

No

Set the Course Categories.
Accepted Values
  • The Application can load data into as many Categories root and sub-categories as exist in the LearnCenter for Courses
  • For format if the data in the column: < category name>;< category name>
  • Each Categories mapping is separated by a semicolon ;
  • The Categories must exist in the LearnCenter
  • The Categories names for the Course must be unique.
  • If multiple Categories (For the Course) with the exact same name exist, the application cannot determine which field to map the data to and will skip the field.
  • Example: Root Categories 01
  • Example: Root Categories 01;Root Categories 02;Root Categories 03
  • Example: Root Categories 01;Root Categories 02; Sub Categories 03;Sub Categories 04
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes

Template Course

Text Editor Column Required Notes
36 AJ

No

Creates the new Course from an existing template Course.
Accepted Values
  • Any Value up to 1000 characters in length
  • Will look for an Existing LearnCenter (WYSIWYG) or Document Course
  • Create a new Course as a copy of the Template Course

Example: Template Placeholder Course

Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes No (Field Skipped) No (Field Skipped) Yes
The Loader will create the new Course from an existing LearnCenter Course including the copying the HTML from the Course Chapters and pages. The New Course will be an exact copy of the existing Template Course

LearnCenter Course Player Show Navigation Bar

Text Editor Column Required Notes
37 AK

No

Set the LearnCenter Course Player to Show Navigation Bar
Accepted Values
  • Inherited = will Inherited setting from the LearnCenter setting
  • Yes = Enables the LearnCenter Course Player to Show Navigation Bar
  • No = Disables the LearnCenter Course Player to Show Navigation Bar
  • Blank or <null> = Set to Inherited
  • Example: Inherited
  • Example: Yes
  • Example: No
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
No (Field Skipped) Yes Yes No (Field Skipped)
Applies to the LearnCenter Course Player only

LearnCenter Course Player Navigation Bar Location

Text Editor Column Required Notes
38 AL

No

Set the LearnCenter Course Player to Show Navigation Bar Location.
Accepted Values
  • Inherited = will Inherited setting from the LearnCenter setting
  • Top = Display at the Top of the Course the Player Navigation Bar
  • Bottom = Display at the Bottom of the Course the Player Navigation Bar
  • Blank or <null> = Set to Inherited
  • Example: Inherited
  • Example: Top
  • Example: Bottom
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
No (Field Skipped) Yes No (Field Skipped) Yes
Applies to the LearnCenter Course Player only

LearnCenter Course Player Show Navigation Buttons

Text Editor Column Required Notes
39 AM

No

No Set the LearnCenter Course Player to Show Navigation Buttons.
Accepted Values
  • Inherited = will Inherited setting from the LearnCenter setting
  • Yes = Enables the LearnCenter Course Player to Show Navigation Buttons
  • No = Disables the LearnCenter Course Player to Show Navigation Buttons
  • Blank or <null> = Set to Inherited
  • Example: Inherited
  • Example: Yes
  • Example: No
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
No (Field Skipped) Yes No (Field Skipped) Yes
Applies to the LearnCenter Course Player only

LearnCenter Course Player Height

Text Editor Column Required Notes
40 AN

No

Set the LearnCenter Course Player Height when launched in a Widget.
Accepted Values

Numeric value from 1 to 9999

Example: 1024

Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
No (Field Skipped) Yes No (Field Skipped) Yes
Applies to the LearnCenter Course Player only

Expire Attempts - Override LearnCenter Default

Text Editor Column Required Notes
41 AO

No

Overrides the LearnCenter setting to set Expire Attempts at the individual Course Level.
Accepted Values
  • Accepts predefined values to Override the LearnCenter setting for the individual Course
  • No = Inherited setting from the LearnCenter
  • Never = Course attempts never expires
  • On = Course Attempt expires on a predefined date
  • After = Course Attempt expires after a defined number of Days, Mounts, or Years
  • Example: No
  • Example: Never
  • Example: On
  • Example: After
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes
No Values will clear the setting at the Course level and Course will Inherit the LearnCenter setting
Never, On, or After will override the LearnCenter level setting and set the Expire Attempts at the Course level.
When you select On, column 42 is required to have the date to Expire the Attempts
When you select After, column 43 and 44 are required to have the interval to expire the attempt

Expire Attempts – On

Text Editor Column Required Notes
42 AP

Yes

If Column 41 = On

Overrides the LearnCenter setting to set Expire Attempts at the individual Course Level on a defined number of Days =, Mounts, or Years.
Accepted Values
  • The Date format must be posted in the mm/dd/yyyy hh
  • mm = Two digit month dd = Two digit Day yyyy = Four digit Year
  • The date will appear based on the system setting
  • Example: 01/02/2015
  • Example: 12/31/2018
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes
Required if Column 41 Expire Attempts - Override LearnCenter Default is set to On
See Requirements for Bulk Loader Source Files for information on formatting dates.
Custom Excel Field Type Format: mm/dd/yyyy

Expire Attempts - After Interval

Text Editor Column Required Notes
43 AQ

Yes

If Column 41 = After

Overrides the LearnCenter setting to set Expire Attempts at the individual Course Level.
Accepted Values
  • Accepts predefined values for the interval to Expire the Attempt
  • Days = Expires the Attempt in a Number of Days
  • Months = Expires the Attempt in a Number of Months
  • Years = Expires the Attempt in a Number of Years
  • Example: Days
  • Example: Months
  • Example: Years
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes
Required if Column 41 Expire Attempts - Override LearnCenter Default is set to On

Expire Attempts - After Value

Text Editor Column Required Notes
44 AR

Yes

If Column 41 = After

Attempts at the individual Course Level.
Accepted Values

Numeric value from 1 to 9999

Example: 90

Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes
Required if Column 41 Expire Attempts - Override LearnCenter Default is set to On

Expire Completions- Override LearnCenter Default

Text Editor Column Required Notes
45 AS

No

Overrides the LearnCenter setting to set Expire Completions at the individual Course Level.
Accepted Values
  • Accepts predefined values to Override the LearnCenter setting for the individual Course
  • No = Inherited setting from the LearnCenter
  • Never = Course Completions never expires
  • On = Course Completion expires on a predefined date
  • After = Course Completion expires after a defined number of Days, Mounts, or Years
  • Example: No
  • Example: Never
  • Example: On
  • Example: After
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes
No Values will clear the setting at the Course level and Course will Inherit the LearnCenter setting
Selecting Never, On, or After will override the LearnCenter level setting and set the Expire Completions at the Course level.
When you select On, column 46 is required to have the date to Expire the Completions
When you select After, then column 47 and 48 are required to have the interval to expire the Completion

Expire Completions – On

Text Editor Column Required Notes
46 AT

Yes

If Column 45 = On

Overrides the LearnCenter setting to set Expire Completions at the individual Course Level on a defined number of Days =, Mounts, or Years.
Accepted Values
  • The Date format must be posted in the mm/dd/yyyy hh
  • mm = Two digit month dd = Two digit Day yyyy = Four digit Year
  • The date will appear based on the system setting
  • Example: 01/02/2015
  • Example: 12/31/2018
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes
Required if Column 45 Expire Completions - Override LearnCenter Default is set to On.
See Requirements for Bulk Loader Source Files for information on formatting dates.
Custom Excel Field Type Format: mm/dd/yyyy

Expire Completions - After Interval

Text Editor Column Required Notes
47 AU

Yes

If Column 45 = After

Overrides the LearnCenter setting to set Expire Completions at the individual Course Level.
Accepted Values
  • Accepts predefined values for the interval to Expire the Completion
  • Days = Expires the Completion in a Number of Days
  • Months = Expires the Completion in a Number of Months
  • Years = Expires the Completion in a Number of Years
  • Example: Days
  • Example: Months
  • Example: Years
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes
Required if Column 45 Expire Completions - Override LearnCenter Default is set to After.

Expire Completions - After Value

Text Editor Column Required Notes
48 AV

Yes

If Column 41 = After

Overrides the LearnCenter setting to set Expire Completions at the individual Course Level.
Accepted Values

Numeric value from 1 to 9999

Example: 90

Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes Yes Yes
Required if Column 41 Expire Attempts - Override LearnCenter Default is set to After

View All Pages

Text Editor Column Required Notes
49 AW

No

Overrides the LearnCenter setting to set Expire Set the additional completion criteria for the document Course to require view all pages.
Accepted Values
  • No = Sets the Document Course to NOT require all pages be view for a completion
  • Yes = Sets the Document Course to require all pages be view for a completion
  • Blank or <null> = Sets to No
  • Example: Yes
  • Example: No
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
No (Field Skipped) No (Field Skipped) No (Field Skipped) Yes

Time In Course

Text Editor Column Required Notes
50 AX

No

Set the additional completion criteria for the document Course to require a minimum time in the Course.
Accepted Values
  • The Time format must be posted in hh:mm:ss in 15 second intervals format
  • hh = Two digit hour mm = Two digit minute ss = Two digit second
  • The time will appear based on the system setting
  • Example: 00:10:00
  • Example: 02:15:45
Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
No (Field Skipped) No (Field Skipped) No (Field Skipped) Yes
Applies to Document Courses created from the Content Manager.
Refer to the Bulk Data Loader Working With Microsoft Excel for Tips on formatting your Microsoft Excel Source file to set the date format correctly in your upload data file.
Custom Excel Field Type Format: hh:mm:ss

Allow Document Download

Text Editor Column Required Notes
51 AY

No

Indicates whether you want to download the document course to download.
Accepted Values
  • Yes = Allows document course to download.
  • No = Does not allow document course to download.
  • Blank or <null> = Inherited.
  • Example: Yes
  • Example: No

LearnCenter Course Player Default Launch Mode

Text Editor Column Required Notes
52 AZ

No

Indicates your LearnCenter Course Player Launch Mode preference
Accepted Values
  • Inherited - uses the launch mode setting is inherited from the parent LearnCenter.
  • Embed - the Course is embedded on the page.
  • New Window or Tab - the Course opens in a new window or tab.

Example: Embed

Example: New Window or Tab

Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
Yes Yes No (Field Skipped) Yes

LearnCenter Course Player Multiple Attempts.

Text Editor Column Required Notes
53 BA

No

Sets your preference for multiple attempts for the Document or SCORM 1.2 Course.
Accepted Values
  • Yes - Courses can be attempted multiple times.
  • No - Courses can be attempted once.

Example: Yes

Example: No

Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
No (Field Skipped) Yes No (Field Skipped) Yes

File Path

Text Editor Column Required Notes
54 BB

No

Updates the file path to the SFTP location for a SCORM Course.
Accepted Values
  • Updates the file path to the SFTP location for a SCORM Course
  • Accepts the SFTP path to the file that launches the Course

Example: /files/scorm/<Path to Course>

Course Types Supported by this Field
LearnCenter Courses SCORM Courses AICC Courses Document Courses
No (Field Skipped) Yes No (Field Skipped) No (Field Skipped)
IMPORTANT: Use the field only if the SCORM Course path has been moved or renamed on the SFTP after import and the Course is being launched in the LearnCenter Course Player from a Widget. This field cannot be used to update a path for the Standard or Classic Course Player.
Refer to the Bulk Data Loader Working With Microsoft Excel for Tips on formatting your Microsoft Excel Source file to set the date format correctly in your upload data file.
Applies only to SCORM 1.2 Course being launched from the LearnCenter Course Player.

Related Topics IconRelated Topics

 

Copyright © 2010-2018, Oracle and/or its affiliates. All rights reserved.